package com.example.podcaster.databaseInterfaces;

public interface ISearchParameters
{
    public final String findPodcastWithGenre = "select podcast.title, genre.[name], podcast.[_id], podcast.is_Video from podcast podcast, podcast_genre podcastGenre, genre genre where podcast.[_id] = podcastGenre.[podcast_id] and genre.[_id] = podcastGenre.[genre_id] and genre.[name] like ? order by title COLLATE NOCASE";

    public final String findGenreArrayWithPodcastID = "select genre.[name], podcast.[_id], podcast.title  from podcast podcast, podcast_genre podcastGenre, genre genre where podcast.[_id] = podcastGenre.[podcast_id] and genre.[_id] = podcastGenre.[genre_id] and podcast.[_id] = ?";

    public final String showListStart = "select _id, name from list l where l.[type] = 'start'";

    public final String showListStartPodcastNames = "select title, _id from podcast p, podcast_list l where p.[_id] = l.[podcast_id] and l.[list_id] = ?";

    public final String searchTitle = "select title from podcast where title = ?";

    public final String searchDescription = "select description from podcast where description = ?";

    public final String searchAuthor = "select author from podcast where author =?";

    public final String searchAll = "select distinct p.title, p.[author] from genre g, podcast_genre pg, podcast p where p.description = ? or author = ? or p.[title] = ?";
}
